SAP Application setup | Qlik Replicate Help
Skip to main content Skip to complementary content

SAP Application setup

Last updated: 2026-11-16

After the ABAP package is installed, an SAP admin registers each table for capture and starts the scheduler before the tables can be used in a Qlik Replicate task. For package installation, see Prerequisites.

Capture data objects

The ABAP package stores its capture metadata and logs in the registered QTQVC namespace. It also creates snapshot and changelog tables for each registered source table.

SAP HANA RFC capture objects
Object Purpose
CDC_REG Lists registered tables, their enabled state, and status.
CDC_SUB Stores each subscriber and table's watermark, polling interval, and retention. The oldest unconsumed watermark across subscribers sets the cleanup boundary.
CDC_AMDP Stores per-table capture metadata, including primary-key columns and the snapshot pair names.
CDC_FCAT Caches column types, lengths, and key flags for interpreting row data.
CDC_CFG Stores global minimum polling interval, maximum retention, and parallelism limits.
CDC_RLOG Records rows changed, anomalies, and errors for capture cycles.
CDC_DIDX Indexes tables with changes in each cycle so Replicate can find changes for a subscription.
SNAP_<table_id>_ID1 and SNAP_<table_id>_ID2 Store the primary-key and row-ID snapshot pair for a registered table.
CDC_CLOG_<table_id> Stores the source-column values and operation and timestamp for each captured change.

Register a table

  1. Run transaction /QTQVC/HRFC_COCKPIT to open the SAP HANA RFC Endpoint Cockpit.
  2. Click Register and enter the SAP table name in Table ID.
  3. Select CDC Enabled.
  4. Set Poll Interval (Min.), the lowest allowed change-generation interval for this table.
  5. Set Retention Per (Hrs), the number of hours to keep change records before cleanup.
  6. Click Save.

A registered table remains PAUSED until a task subscribes to it. Only registered and enabled tables appear in the source table selector.

If no task requests changes for a table for a while, SAP pauses capture for that table. Capture resumes automatically when a task subscribes again.

Information note

The SAP admin's global settings establish the minimum polling interval, maximum retention, and parallelism ceiling for subscriptions. SAP applies these limits. When SAP adjusts a requested polling interval or retention value, Qlik Replicate logs a warning.

Start the scheduler

Start the scheduler watchdog once. It then realigns the capture jobs to the fastest polling interval requested by active subscriptions.

  1. Run transaction /QTQVC/HRFC_COCKPIT to open the SAP HANA RFC Endpoint Cockpit.
  2. Click the Schedule Job button.
  3. Set Program Name to /QTQVC/CDC_SCHEDULER.
  4. Set Action to Schedule (new job).
  5. Set Job Name to /QTQVC/CDC/SCHEDULER.
  6. Set Period. The default is 5 minutes.
  7. Click Execute.

Do not rename the watchdog job or change the capture job prefix after setup. The scheduler finds jobs by their current names. A renamed job is not realigned or cleaned up automatically.

Schedule the housekeeping job

Schedule the housekeeping job to remove processed changelog entries from the changelog tables based on retention time.

  1. Run transaction /QTQVC/HRFC_COCKPIT to open the SAP HANA RFC Endpoint Cockpit.
  2. Click the Schedule Job button.
  3. Set Program Name to /QTQVC/CDC_HOUSEKEEPING.
  4. Set Action to Schedule (new job).
  5. Set Job Name to /QTQVC/CDC_HOUSEKEEPING.
  6. Set Period. The default is 1440 minutes (1 day).
  7. Click Execute.

For dry-run, stop, resume, and cleanup options, see Schedule and manage capture jobs.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!